How to: Combine criteria in a query with a logical AND or OR.

Solution:


Click the 'Queries' tab in the Database window, click 'New', and select 'Design View' from the list box. Type the desired data expression using AND or OR in the 'Criteria' cell(s) of the appropriate fields.